PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 1 ANTHISTLE SYSTEMS & PROGRAMMING LTD. 563 Patricia Drive, Oakville, Ontario, CANADA L6K 1M4 Telephone (416) 845 7959 8th. February, 1990 SAMPLE REPORTS FROM OUR PAYROLL USA SYSTEM ========================================== These are sample reports from PAYUSCYC.EXE (Pay Cycle), PAYUSPRT.EXE (Print Internal Reports) and the PRINTGOV.EXE (Print Government Reports) programs. You may print these sample reports if you wish by using the DOS COPY command. Line up your printer and at the DOS Prompt for \PAYSLIDE type COPY SAMP_RPT.TXT PRN and press Enter. About 26 pages will be printed. 1. REPORTS FROM PAYUSCYC.EXE (Pay Cycle) ========================================= When processing a pay cycle the same edits are applied as are applied when the cursor passes over a field on the PAYUSEDT.EXE (Employee Add / Update) screens. Instead of pop up windows any results of those edits are printed out on a status report like this. Before processing the employees are sorted into alphabetical order within status and pay method. PAYROLL CALCULATION - STATUS REPORT Page 1 PROCESSED ON 07-Feb-1990 at 18:31 hrs. YOUR COMPANY NAME THE FOLLOWING EMPLOYEES ARE STATUS "A" AND PAY METHOD "H" : Processing Anderson, Janette SSN 874-04-5116 Empl# 8 Processing Carter, Pauline SSN 368-12-1382 Empl# 10 Processing Davis, George SSN 193-64-3728 Empl# 9 Processing Davis, Gillian SSN 595-27-8117 Empl# 7 Processing Lalonde, Norman SSN 781-08-5653 Empl# 6 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 2 PAYROLL CALCULATION - STATUS REPORT Page 2 PROCESSED ON 07-Feb-1990 at 18:32 hrs. YOUR COMPANY NAME THE FOLLOWING EMPLOYEES ARE STATUS "A" AND PAY METHOD "S" : Processing Anderson, Thomas SSN 961-04-8467 Empl# 1 Processing Thompson, Gillian SSN 600-80-7768 Empl# 5 Processing Walsh, George SSN 817-98-2857 Empl# 3 Processing Yates, Susan SSN 974-33-5014 Empl# 4 Processing Zylik, Thomas SSN 170-56-9330 Empl# 2 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 3 2. REPORTS FROM PAYUSPRT.EXE (Internal Reports) ================================================ 2a. Reports based on PAYUSA.DTA (Employee) file ------------------------------------------------ Each employee's basic information can be printed out in a format which looks exactly like the first three employee update screens of PAYUSEDT.EXE . This optional print out is however done from PAYUSPRT.EXE . You can select to print all employees or skip printing of terminated employees. You cannot do individual employees, if you need that bring them up on the PAYUSEDT (Employee Update) Screens and use the Shift PrtSc feature of your computer. PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 4 EMPLOYEE INFORMATION PRINTED ON 07-Feb-1990 at 18:38 hrs. =============================== SSN 874-04-5116 EMPL NUM 8 PREV EMPL NUM SURNAME Anderson FIRST NAME Janette STREET 173 Kerr Street PHONE 416-845-7959 TOWN SACRAMENTO STATE California ZIP CODE 94299-1234 SEX F MARRIED S YR BORN 1964 MO BORN 7 DAY BORN 10 AGE 25 OCCUPATION Secretary EMPLOYEE TYPE REG EMPLOYEE STATUS A YR LAST REVIEW 1989 MO LAST REVIEW 4 DAY LAST REVIEW 26 YR NEXT REVIEW 1990 MO NEXT REVIEW 4 DAY NEXT REVIEW 26 PAY METHOD H SALARY TERRITORY II SALARY LEVEL 11 SALARY PERFORMANCE C ANNUAL SALARY 0.00 HOURLY RATE 9.2500 PAY FREQ 26 OVERTIME PERMITTED TRUE VACATION ACCRUAL P'CENT 4.0000 VACATION ALLOW 10day VACATION TAKEN SICK ACCRUAL P'CENT 0.0000 SICK ALLOW SICK TAKEN START YEAR 1988 START MO 4 START DAY 26 END YEAR 0 END MO 0 END DAY 0 REASON TERMINATED EXEMPT FED TAX FALSE VOL FED ADDTNL WHOLDG 0.00 NUM OF FED EXEMPTIONS 3 EIC W5 FILED FALSE EIC W5 SPOUSE FILED FALSE W2 BOX 16 LINE 1 DESC Employer Contrb W2 BOX 16 LINE 2 DESC 401(k), etc. EXEMPT SOC SEC FALSE MEDICARE QUALIFIED FED EMPL FALSE EXEMPT FUTA FALSE EXEMPT STATE TAX FALSE VOL STATE ADDTNL WHOLDG 0.00 NUM OF REG. STATE EXEMPTIONS 3 NUM OF ADDL. STATE EXEMPTIONS 0 EXEMPT SUTA FALSE EXEMPT LOCAL TAX TRUE NUM OF LOCAL EXEMPTIONS 0 NON RESIDENT FOR LOCAL FALSE PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 5 We also made provision to optionally print out mailing labels. This also is done in PAYUSPRT.EXE . You can select to print all employees or skip printing of terminated employees. Janette Anderson 173 Kerr Street SACRAMENTO California 94299-1234 George Davis 258 Chartwell SACRAMENTO California 94299-1234 Gillian Davis 840 White Oakes SACRAMENTO California 94299-1234 Norman Lalonde 892 Kerr Street SACRAMENTO California 94299-1234 Thomas Anderson 290 Lakeshore Rd. W. SACRAMENTO California 94299-1234 Gillian Thompson 422 Bronte Rd. SACRAMENTO California 94299-1234 George Walsh 117 Trafalgar Rd. SACRAMENTO California 94299-1234 Susan Yates 847 Sandlewood SACRAMENTO California 94299-1234 Thomas Zylik 162 Pinegrove SACRAMENTO California 94299-1234 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 6 2b. Reports based on PAYUSCUR.DTA / PAYUSYTD.DTA files (The Current and YTD Accounting Extract Files) ------------------------------------------------------- The Accounting Files extracted by the Pay Cycle, PAYUSCUR.DTA AND PAYUSYTD.DTA, are used to produce ALL the remaining reports produced by PAYUSPRT.EXE. These files are sorted on G.L. Account Number, Branch, and Department so that is the sequence the Employees appear in on the remaining reports. We have provided a means (in the Configuration Program) to allow you to change the "Other" type lines on the checks, pay slips, and pay register to read whatever you wish - e.g. "Ded. Othr 1" might be changed to read "Calif. SDI". You may also enter and save your own G.L. Account Numbers, through the Configuration Program, for printing on the Journal Report. Except for the W2's the remaining reports are first sorted into alphabetical order within G.L./Branch/Dept/Project so they can be sub totalled on G.L./Branch/Dept/Project. For Companies who have a cash payroll, or who prefer to issue manual checks, pay slips can be printed as follows. If folded on the dotted line they will fit into window envelopes for distribution. Note that only non zero items are printed to reduce clutter. Even if you are using manual checks we still provide you with a Check Register, except you have to enter the check numbers yourself. PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 7 YOUR COMPANY NAME EMPLOYEE PAY STATEMENT FOR 16-Feb-1990 Employee Number 7 Social Security No. 595-27-8117 Branch Code SAC Dept. Code ACT Gillian Davis 840 White Oakes SACRAMENTO California 94299-1234 --- CURRENT AND YTD FIGURES: Hourly Rate 10.75 0.00 Reg Pay Hours 75.00 300.00 Otime 1 Hrs 5.00 20.00 Reg Wages 806.25 3225.00 Otime 1 Amt 80.63 322.52 Shift Premium 24.30 97.20 Tot Actl. Pay 911.18 3644.72 Taxable Pay 911.18 3644.72 Federal Tax 94.27 377.08 State Tax 23.68 94.72 FICA Soc Sec. 69.70 278.80 Ded. Medical 20.00 80.00 Ded. Dental 10.00 40.00 Ded.Soc. Club 5.00 20.00 Calif. SDI 8.20 32.80 Total Deduct 230.85 923.40 Net Pay 680.33 2721.32 Issue Check 680.33 2721.32 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 8 PAYROLL CHECK REGISTER Page 1 ======================= PROCESSED ON 07-Feb-1990 at 18:34 hrs. YOUR COMPANY NAME Check Check Employee Name Check Number Date (Payee) Amount ------ ---- ------------- ------- _________ 16-Feb-1990 Gillian Davis 680.33 _________ 16-Feb-1990 Thomas Zylik 1106.54 _________ 16-Feb-1990 Norman Lalonde 800.38 _________ 16-Feb-1990 Gillian Thompson 829.66 _________ 16-Feb-1990 George Walsh 1052.33 _________ 16-Feb-1990 Susan Yates 970.13 _________ 16-Feb-1990 Thomas Anderson 1745.96 _________ 16-Feb-1990 Janette Anderson 593.71 _________ 16-Feb-1990 Pauline Carter 350.80 _________ 16-Feb-1990 George Davis 508.90 Total Checks Issued 8638.74 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 9 As an alternative to Pay Slips you may optionally print Checks with the pay slip information on the tear off stub. The Checks are formatted to fit on Carbonless Multi-Purpose Check Forms such as the DeLuxe Check Form #091004 or the Moore Business Products Check Series 7030. DeLuxe have a toll free order line 1-800-356-7552 , please mention our keycode CO5778 (letters CO, numbers 5778) to ensure fastest service. The employee name and address is in the correct position for a window envelope. The checks of course are continuous forms, with tear off tractor feed holes, for your system printer. This is a very popular 7 inch long form with the check on the TOP half and a blank stub on the bottom 3 1/2 inches of the form, there are no pre-printed boxes on the stub so the same form may also be used for Accounts Payable. If your existing check form has a blank stub on the top rather than the bottom it may still be usable by starting the print half way down the first check so the stub of the second check is used for the first check. Only non zero items are printed on the Check stubs, and a Check Register is also printed, like this FIRST A LINE UP CHECK (Repeats as many times as needed) CHECKS ARE SPACED 7 INCHES APART (NOT SHOWN HERE) ------------------------------------------------------- 12345678 Six Hundred Eighty and 33/100 16-Feb-1990 $****680.33 **************** ****************, *********************************, *********************************, **********************, *****-**** 12345678 CURR. & YTD PAY **************** ****************, 16-Feb-1990, Empl# ********* Hourly Rate 10.75 0.00 Total Deduct 230.85 0.00 Reg Pay Hours 75.00 0.00 Net Pay 680.33 0.00 Otime 1 Hrs 5.00 0.00 Issue Check 680.33 0.00 Reg Wages 806.25 0.00 Otime 1 Amt 80.63 0.00 Shift Premium 24.30 0.00 Tot Actl. Pay 911.18 0.00 Taxable Pay 911.18 0.00 Federal Tax 94.27 0.00 State Tax 23.68 0.00 FICA Soc Sec. 69.70 0.00 Ded. Medical 20.00 0.00 Ded. Dental 10.00 0.00 Ded.Soc. Club 5.00 0.00 Calif. SDI 8.20 0.00 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 10 THEN THE ACTUAL CHECKS (Some omitted from here to save space) FOLLOWED BY THE CHECK REGISTER. ------------------------------------------------------------- 123456 Six Hundred Eighty and 33/100 16-Feb-1990 $****680.33 Gillian Davis, 840 White Oakes, SACRAMENTO, California, 94299-1234 123456 CURR. & YTD PAY Gillian Davis, 16-Feb-1990, Empl# 7 Hourly Rate 10.75 0.00 Total Deduct 230.85 923.40 Reg Pay Hours 75.00 300.00 Net Pay 680.33 2721.32 Otime 1 Hrs 5.00 20.00 Issue Check 680.33 2721.32 Reg Wages 806.25 3225.00 Otime 1 Amt 80.63 322.52 Shift Premium 24.30 97.20 Tot Actl. Pay 911.18 3644.72 Taxable Pay 911.18 3644.72 Federal Tax 94.27 377.08 State Tax 23.68 94.72 FICA Soc Sec. 69.70 278.80 Ded. Medical 20.00 80.00 Ded. Dental 10.00 40.00 Ded.Soc. Club 5.00 20.00 Calif. SDI 8.20 32.80 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 11 PAYROLL CHECK REGISTER Page 1 ======================= PROCESSED ON 07-Feb-1990 at 18:33 hrs. YOUR COMPANY NAME Check Check Employee Name Check Number Date (Payee) Amount ------ ---- ------------- ------- 123456 16-Feb-1990 Gillian Davis 680.33 123457 16-Feb-1990 Thomas Zylik 1106.54 123458 16-Feb-1990 Norman Lalonde 800.38 123459 16-Feb-1990 Gillian Thompson 829.66 123460 16-Feb-1990 George Walsh 1052.33 123461 16-Feb-1990 Susan Yates 970.13 123462 16-Feb-1990 Thomas Anderson 1745.96 123463 16-Feb-1990 Janette Anderson 593.71 123464 16-Feb-1990 Pauline Carter 350.80 123465 16-Feb-1990 George Davis 508.90 Total Checks Issued 8638.74 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 12 The Payroll Register can be printed from the current pay period information or from the YTD information. Sub Totals and Totals are printed. If printed from the YTD information note that, so current pay is included, the figures are extracted from PAYUSA.DTA AFTER it has been updated for the most recent pay cycle. Therefore the pay date is set up for the next pay AFTER the last one processed. Note that the YTD figures do not include the pay etc. for the pay date shown - it has not been processed yet. This printed report contains essentially the same information as is in the optional translation to NewViews, dBASE, Symphony, Lotus 123, or PC-File. The translation programs were provided so people who use those programs for their Accounting functions can pick up the figures from the computer file version of this report without having to re-key them. PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 13 PAYROLL REGISTER Page 1 ================ PROCESSED ON 07-Feb-1990 at 18:36 hrs. YOUR COMPANY NAME SSN 595-27-8117 170-56-9330 SUB-TOTAL 781-08-5653 Empl. Num 7 2 FOR 6 Sur Name Davis Zylik G.L. ACCOUNT Lalonde First Name Gillian Thomas AND BRANCH / Norman Annual Salary 0.00 38000.00 DEPARTMENT 0.00 Hourly Rate 10.75 19.49 CODE BREAK 12.25 Pay Day 16-Feb-1990 16-Feb-1990 ************* 16-Feb-1990 G.L. Account Branch Code SAC SAC SAC Dept. Code ACT ACT DEV Charge Projct PAYUSA PAYUSA PAYUSA Comp.Calc Pay YES YES YES Comp.Calc Tax YES YES YES Reg Pay Hours 75.0000 75.0000 75.0000 Otime 1 Hrs 5.0000 5.0000 5.0000 Salary 1461.54 1461.54 Reg Wages 806.25 806.25 918.75 Otime 1 Amt 80.63 80.63 91.88 Shift Premium 24.30 24.30 24.30 Tot Actl. Pay 911.18 1461.54 2372.72 1034.93 Taxable Pay 911.18 1461.54 2372.72 1034.93 Federal Tax 94.27 164.13 258.40 100.14 State Tax 23.68 30.91 54.59 10.93 FICA Soc Sec. 69.70 111.81 181.51 79.17 Ded. Medical 20.00 20.00 40.00 20.00 Ded. Dental 10.00 10.00 20.00 10.00 Ded.Soc. Club 5.00 5.00 10.00 5.00 Calif. SDI 8.20 13.15 21.35 9.31 Total Deduct 230.85 355.00 585.85 234.55 Net Pay 680.33 1106.54 1786.87 800.38 Issue Check 680.33 1106.54 1786.87 800.38 Vac. Accrued 36.45 89.45 125.90 41.40 FUTA Wage 911.18 1461.54 2372.72 1034.93 FUTA Liab 56.49 90.62 147.11 64.17 FUTA State Cr 49.20 78.92 128.12 55.89 SUTA Wage 911.18 1461.54 2372.72 1034.93 SUTA Liab 33.71 54.08 87.79 38.29 941 S.S. Wge 911.18 1461.54 2372.72 1034.93 941 Total 911.18 1461.54 2372.72 1034.93 Amt S.S. Wge 139.41 223.62 363.03 158.34 Amt S.S. Totl 139.41 223.62 363.03 158.34 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 14 PAYROLL REGISTER Page 2 ================ PROCESSED ON 07-Feb-1990 at 18:36 hrs. YOUR COMPANY NAME SSN 600-80-7768 817-98-2857 974-33-5014 SUB-TOTAL Empl. Num 5 3 4 FOR Sur Name Thompson Walsh Yates G.L. ACCOUNT First Name Gillian George Susan AND BRANCH / Annual Salary 30000.00 36000.00 33000.00 DEPARTMENT Hourly Rate 15.38 18.46 16.92 CODE BREAK Pay Day 16-Feb-1990 16-Feb-1990 16-Feb-1990 ************* G.L. Account Branch Code SAC SAC SAC Dept. Code DEV DEV DEV Charge Projct PAYUSA PAYUSA PAYUSA Comp.Calc Pay YES YES YES Comp.Calc Tax YES YES YES Reg Pay Hours 75.0000 Otime 1 Hrs 5.0000 Salary 1153.85 1384.62 1269.23 3807.70 Reg Wages 918.75 Otime 1 Amt 91.88 Shift Premium 24.30 Tot Actl. Pay 1153.85 1384.62 1269.23 4842.63 Taxable Pay 1153.85 1384.62 1269.23 4842.63 Federal Tax 146.67 152.60 135.29 534.70 State Tax 43.87 26.30 20.30 101.40 FICA Soc Sec. 88.27 105.93 97.09 370.46 Ded. Medical 20.00 20.00 20.00 80.00 Ded. Dental 10.00 10.00 10.00 40.00 Ded.Soc. Club 5.00 5.00 5.00 20.00 Calif. SDI 10.38 12.46 11.42 43.57 Total Deduct 324.19 332.29 299.10 1190.13 Net Pay 829.66 1052.33 970.13 3652.50 Issue Check 829.66 1052.33 970.13 3652.50 Vac. Accrued 46.15 84.74 50.77 223.06 FUTA Wage 1153.85 1384.62 1269.23 4842.63 FUTA Liab 71.54 85.85 78.69 300.25 FUTA State Cr 62.31 74.77 68.54 261.51 SUTA Wage 1153.85 1384.62 1269.23 4842.63 SUTA Liab 42.69 51.23 46.96 179.17 941 S.S. Wge 1153.85 1384.62 1269.23 4842.63 941 Total 1153.85 1384.62 1269.23 4842.63 Amt S.S. Wge 176.54 211.85 194.19 740.92 Amt S.S. Totl 176.54 211.85 194.19 740.92 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 15 PAYROLL REGISTER Page 3 ================ PROCESSED ON 07-Feb-1990 at 18:36 hrs. YOUR COMPANY NAME SSN 961-04-8467 SUB-TOTAL 874-04-5116 368-12-1382 Empl. Num 1 FOR 8 10 Sur Name Anderson G.L. ACCOUNT Anderson Carter First Name Thomas AND BRANCH / Janette Pauline Annual Salary 70000.00 DEPARTMENT 0.00 0.00 Hourly Rate 35.90 CODE BREAK 9.25 5.15 Pay Day 16-Feb-1990 ************* 16-Feb-1990 16-Feb-1990 G.L. Account Branch Code SAC SAC SAC Dept. Code EXE SEC SEC Charge Projct PAYUSA PAYUSA PAYUSA Comp.Calc Pay YES YES YES Comp.Calc Tax YES YES YES Reg Pay Hours 75.0000 75.0000 Otime 1 Hrs 5.0000 5.0000 Salary 2692.31 2692.31 Reg Wages 693.75 386.25 Otime 1 Amt 69.38 38.62 Shift Premium 24.30 24.30 Tot Actl. Pay 2692.31 2692.31 787.43 449.17 Fringe Auto. 300.00 300.00 Taxable Pay 2992.31 2992.31 787.43 449.17 Federal Tax 572.75 572.75 75.71 24.97 State Tax 157.76 157.76 15.68 FICA Soc Sec. 228.91 228.91 60.24 34.36 Ded. Medical 20.00 20.00 20.00 20.00 Ded. Dental 10.00 10.00 10.00 10.00 Ded.Soc. Club 5.00 5.00 5.00 5.00 Calif. SDI 26.93 26.93 7.09 4.04 Total Deduct 1021.35 1021.35 193.72 98.37 Net Pay 1670.96 1670.96 593.71 350.80 Entertain Exp 25.00 25.00 Busn. Gas/Oil 50.00 50.00 Issue Check 1745.96 1745.96 593.71 350.80 Vac. Accrued 224.27 224.27 31.50 17.97 FUTA Wage 787.43 449.17 FUTA Liab 48.82 27.85 FUTA State Cr 42.52 24.26 SUTA Wage 787.43 449.17 SUTA Liab 29.13 16.62 941 S.S. Wge 2992.31 2992.31 787.43 449.17 941 Total 2992.31 2992.31 787.43 449.17 Amt S.S. Wge 457.82 457.82 120.48 68.72 Amt S.S. Totl 457.82 457.82 120.48 68.72 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 16 PAYROLL REGISTER Page 4 ================ PROCESSED ON 07-Feb-1990 at 18:36 hrs. YOUR COMPANY NAME SSN 193-64-3728 SUB-TOTAL GRAND TOTAL Empl. Num 9 FOR FOR Sur Name Davis G.L. ACCOUNT THIS First Name George AND BRANCH / PAY PERIOD Annual Salary 0.00 DEPARTMENT Hourly Rate 7.20 CODE BREAK ************* Pay Day 16-Feb-1990 ************* G.L. Account Branch Code SAC Dept. Code SEC Charge Projct PAYUSA Comp.Calc Pay YES Comp.Calc Tax YES Reg Pay Hours 75.0000 225.0000 375.0000 Otime 1 Hrs 5.0000 15.0000 25.0000 Salary 7961.55 Reg Wages 540.00 1620.00 3345.00 Otime 1 Amt 54.00 162.00 334.51 Shift Premium 24.30 72.90 121.50 Tot Actl. Pay 618.30 1854.90 11762.56 Fringe Auto. 300.00 Taxable Pay 618.30 1854.90 12062.56 Federal Tax 37.65 138.33 1504.18 State Tax 15.68 329.43 FICA Soc Sec. 47.30 141.90 922.78 Ded. Medical 20.00 60.00 200.00 Ded. Dental 10.00 30.00 100.00 Ded.Soc. Club 5.00 15.00 50.00 Calif. SDI 5.56 16.69 108.54 Total Deduct 125.51 417.60 3214.93 Net Pay 492.79 1437.30 8547.63 Advance EIC 16.11 16.11 16.11 Entertain Exp 25.00 Busn. Gas/Oil 50.00 Issue Check 508.90 1453.41 8638.74 Vac. Accrued 24.73 74.20 647.43 FUTA Wage 618.30 1854.90 9070.25 FUTA Liab 38.33 115.00 562.36 FUTA State Cr 33.39 100.17 489.80 SUTA Wage 618.30 1854.90 9070.25 SUTA Liab 22.88 68.63 335.59 941 S.S. Wge 618.30 1854.90 12062.56 941 Total 618.30 1854.90 12062.56 Amt S.S. Wge 94.60 283.80 1845.57 Amt S.S. Totl 94.60 283.80 1845.57 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 17 The Summary Journal Report suggest how you may wish to debit and credit your accounting system. It would normally be produced from the CURRENT file, but it can also be produced from the YTD file if for example you wanted to check the balances in some of the G.L. Accounts. Gross pay is broken out by current employee G.L./Branch/Dept/Project identification in case you wish to distribute pay costs between different cost centers within your organization. These codes are on the current hours entry screen for each employee and if entered they are concatonated and used as a sort key on both the Payroll Register (above) and the Journal (below). In the Journal they appear in the 4 lines starting **********SACACTPAYUSA**** (the *'s represent unused codes) PRINTED: 07-Feb-1990 at 18:36 hrs. Page 1 YOUR COMPANY NAME SUMMARY JOURNAL ENTRIES FROM PAYROLL USA SYSTEM FOR PAY DATE 16-Feb-1990 ACCOUNT DESCRIPTION NUMBER DR. CR. ----------- ------ --- --- Gross Pay Debit split by GL/Branch/Dept./Project: **********SACACTPAYUSA**** 5440 2372.72 **********SACDEVPAYUSA**** 5440 4842.63 **********SACEXEPAYUSA**** 5440 2692.31 **********SACSECPAYUSA**** 5440 1854.90 Federal Tax 2510 1504.18 State Tax 2520 329.43 FICA Soc Sec. 2540 922.78 Ded. Medical 2600 200.00 Ded. Dental 2610 100.00 Ded.Soc. Club 2650 50.00 Calif. SDI 2680 108.54 Net Pay 1100 8547.63 ----------- ----------- TO RECORD EMPLOYEE PAY 11762.56 11762.56 =========== =========== ^ |___ NOTE, YOUR OWN GL ACCOUNT NUMBERS CAN BE PRINTED HERE IF ENTERED IN THE CONFIGURATION SECTION. PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 18 PRINTED: 07-Feb-1990 at 18:36 hrs. Page 2 YOUR COMPANY NAME SUMMARY JOURNAL ENTRIES FROM PAYROLL USA SYSTEM FOR PAY DATE 16-Feb-1990 ACCOUNT DESCRIPTION NUMBER DR. CR. ----------- ------ --- --- Fringe Auto. 5460 300.00 Advance EIC 2510 16.11 Entertain Exp 5760 25.00 Busn. Gas/Oil 5770 50.00 Vac. Accrued 5820 647.43 FUTA less St.Cr. 5840 72.56 COMPANY SUTA 5870 335.59 COMPANY FICA 5850 922.79 Fringe Auto. 2460 300.00 Advance EIC 1100 16.11 Entertain Exp 1100 25.00 Busn. Gas/Oil 1100 50.00 Vac. Accrued 2820 647.43 FUTA less St.Cr. 2840 72.56 COMPANY SUTA 2870 335.59 COMPANY FICA 2850 922.79 ----------- ----------- TO RECORD ADDL. EMPLOYEE EXP. 2369.48 2369.48 =========== =========== ^ |___ NOTE, YOUR OWN GL ACCOUNT NUMBERS CAN BE PRINTED HERE IF ENTERED IN THE CONFIGURATION SECTION. PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 19 3. REPORTS FROM PRINTGOV.EXE ============================= This program is restricted to REGISTERED USERS ONLY. It prints a variety of Government Reports, 941, 940, Quarterly State Unemployment, and W-2's. The 941 and 940 are in the form of worksheets, the Quarterly State Unemployment is probably usable as is in most States, and the W-2's follow the layout of the IRS form, though that form is too thick to print on. If you can obtain commercial pin feed equivalents with the same spacing you can print directly on them, multiple times if necessary, else you will have to transfer the information by hand to the IRS form. PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 20 IRS FORM 941 (FICA and FED.TAX) WORKSHEET FOR QUARTER 4 OF 1989 38-0000000 YOUR COMPANY NAME 999 Main Street Your Co. Town Your State 12345-6789 2 Wages etc. Subj. Withholding 86046.30 3 Income Tax Withheld 13428.56 5 Adjusted Income Tax Withheld 13428.56 6 Taxable Soc.Sec. Wages Paid 62261.42 Social Sec. Tax on Wages 9526.02 7a Taxable Tips 0.00 Social Sec. Tax on Tips 0.00 7c Taxable Hospital Insc. Wages 0.00 Social Sec. Tax on Hospital 0.00 8 Total Social Sec. Taxes 9526.02 10 Adjusted Social Sec. Taxes 9526.02 14 Total Taxes 22954.58 15 Advance Earned Inc. Credit 80.55 16 Net Taxes 22874.03 17 Total Deposits (add your Federal Tax Deposit Coupons, IRS Form 8109, 941 Taxes for this Quarter, or refer to your Accounting System record of tax deposits actually made, then also complete lines 18 and 19 of the 941 form). The following table has details of your Federal Income Tax & FICA liability as recorded by PAYROLL USA. It corresponds to the table on the 941 form and the dates will help you verify that this is a complete quarters figures (BE PARTICULARLY CAREFUL IN THE FIRST QUARTER THAT YOU STARTED USING VERSION 2.0 OR LATER OF PAYROLL USA - FIGURES WILL NOT BE COMPLETE IF YOU STARTED THIS VERSION PART WAY INTO THIS QUARTER). It may not be necessary to copy all of this table onto the 941 form, in fact if line 16 above is less than $500.00 none of it need be copied. What needs to be copied depends on the amounts - see the IRS rules on deposits if in doubt. The figures below will need adjustment if you are making any manual adjustments to the figures above as the total for the quarter (below) must balance to line 16 (above). Days First Month Second Month Third Month 1 - 3 A 0.00 I 0.00 Q 0.00 4 - 7 B 0.00 J 0.00 R 0.00 8 - 11 C 0.00 K 2782.13 S 2782.13 12 - 15 D 2782.13 L 0.00 T 0.00 16 - 19 E 0.00 M 0.00 U 0.00 20 - 22 F 0.00 N 0.00 V 8963.38 23 - 25 G 0.00 O 2782.13 W 0.00 26 - 31 H 2782.13 P 0.00 X 0.00 MONTHLY I 5564.26 II 5564.26 III 11745.51 IV TOTAL FOR QUARTER 22874.03 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 21 IRS FORM 940 (FUTA) WORKSHEET FOR 1989 38-0000000 YOUR COMPANY NAME 999 Main Street Your Co. Town Your State 12345-6789 A All contributions to SUTA paid [X] YES [ ] NO Amount of SUTA paid 2330.95 B Are ALL SUTA contributions one State [X] YES [ ] NO State Name CALIF. State Reporting Number 99-0000000 "A" will be marked NO if there is no Employer SUTA Liability on file. "B" is based ONLY on this employee file, if you are using multiple employee files for the same company you may need to modify this answer (and add figures from the other files) "C" will be marked YES if SUTA Wage on file is less than FUTA Wage Please verify the above answers are correct. PART I 1 Total Wages, etc. 318314.10 2 Exempt Payments 0.00 3 Excess over FUTA max. 255314.10 4 Total Exempt 255314.10 5 Total Taxable Wages 63000.00 "2 Exempt Payments" is determined by summing taxable pay for employees who have "EXEMPT FUTA" set to TRUE on the tax setup screen. This should be set only for those who really are exempt, not needed just to stop contributions when the limit is reached (that is automatic). Adjust by completing line 6 if necessary. COMPLETE EITHER (PART II) OR (PART III + PART V), PLUS PART IV PAYROLL USA ASSUMES YOU ARE COMPLETING PART II, IT DOES NOT HAVE SUFFICIENT INFORMATION TO PROVIDE THE FIGURES FOR PART III + PART V - IF YOU NEED TO COMPLETE PART III + PART V (I.E. YOUR ANSWER TO EITHER A OR B IS "NO" OR YOU NEEDED TO CHECK C) THEN YOU MUST DO IT MANUALLY PART II 1 FUTA Tax 503.98 3 Total FUTA Tax 503.98 Adjust by completing line 2 if necessary, then complete lines 4, 5, and 6 AFTER referring to your Accounting System to find the deposits of 940 tax actually made. PART IV First Second Third Fourth Total Yr. Liability for Quarter 465.75 38.23 0.00 0.00 503.98 PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 22 Figures shown in PART IV assume that PAYROLL USA Vers. 2.0 or later has been in use for the full year AND that you qualify to complete PART II AND that no manual adjustments were made to the figures printed above for PART I line 5 or PART II line 3. PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 23 YOUR COMPANY NAME CALIF. STATE ID 99-0000000 FEDERAL ID 38-0000000 STATE UNEMPLOYMENT QUARTERLY REPORT WORKSHEET FOR QUARTER 4 OF 1989 PAGE 1 Soc.Sec.Num. First & Last Name Total Wage ------------ ----------------- ---------- 874-04-5116 Janette ANDERSON 5543.58 193-64-3728 George DAVIS 4352.78 595-27-8117 Gillian DAVIS 6414.78 781-08-5653 Norman LALONDE 7285.98 961-04-8467 Thomas ANDERSON 23784.88 600-80-7768 Gillian THOMPSON 8123.00 817-98-2857 George WALSH 10510.96 974-33-5014 Susan YATES 8935.40 170-56-9330 Thomas ZYLIK 11094.94 ---------- TOTAL WAGES LISTED ON THIS PAGE 86046.30 ---------- TOTAL WAGES LISTED ON ALL PAGES 86046.30 ========== PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 24 YOUR COMPANY NAME CALIF. STATE ID 99-0000000 FEDERAL ID 38-0000000 STATE UNEMPLOYMENT QUARTERLY REPORT WORKSHEET FOR QUARTER 4 OF 1989 PAGE 2 NUMBER OF WORKERS LISTED 9 ==== TOTAL WAGES PAID 86046.30 LESS WAGES IN EXCESS OF SUTA LIMIT 86046.30 ---------- TAXABLE WAGES 0.00 ========== Complete the Calculation on the official form. The above figures assume you have been using Vers. 2.0 or later of PAYROLL USA for the whole of this Quarter. According to the calculations done by PAYROLL USA your Quarterly State Unemployment Liability is: Employee Paid State Unemployment 0.00 Company Paid State Unemployment 0.00 ---------- TOTAL State Unemployment Liability 0.00 ========== PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 25 W-2 PRINTING. ------------- Note the SUB TOTAL and TOTAL W2's produced at the end for these 9 employees. The sub total goes to the IRS so it is counted as a W2. The total is for transfer to the transmittal slip and should not be sent to the IRS as a W2. 8 YOUR COMPANY NAME 38-0000000 99-0000000 999 Main Street Your Co. Town Your State 12345-6789 0.00 0.00 874-04-5116 2166.15 21292.18 1628.89 Janette ANDERSON 21292.18 0.00 Employer Contrb 173 Kerr Street 401(k), etc. SACRAMENTO California 94299-1234 477.96 21292.18 CALIF. 9 YOUR COMPANY NAME 38-0000000 99-0000000 999 Main Street Your Co. Town Your State 12345-6789 0.00 402.75 193-64-3728 1075.35 16718.78 1278.99 George DAVIS 16718.78 0.00 Employer Contrb 258 Chartwell 401(k), etc. SACRAMENTO California 94299-1234 19.99 16718.78 CALIF. -------- Some W-2 forms included in the following totals were removed from this file SAMP_RPT.TXT to reduce the size of the print out. --------- PAYROLL USA SAMPLE REPORTS, FEB. 1990 - PAGE 26 YOUR COMPANY NAME 38-0000000 99-0000000 999 Main Street Your Co. Town X Your State 12345-6789 0.00 402.75 43012.76 318314.10 21877.61 ** SUB TOTAL ** 285983.02 0.00 YOUR COMPANY NAME 38-0000000 99-0000000 999 Main Street Your Co. Town X Your State 12345-6789 0.00 402.75 43012.76 318314.10 21877.61 *** TOTAL *** 285983.02 0.00 10 W2 FORMS, T'FER FIGURES TO W3 TRANSMITTAL FORM